package demo1.dao.Mapper;

import demo1.pojo.goods;

import java.sql.ResultSet;
import java.sql.Timestamp;
import java.util.List;

public interface goodsMapper {
    List<goods> selectById(int id) throws Exception;
    void addGoods(int price,String goodsMessage,String goodsName,String goodsType,int goodsNum,int id) throws Exception;
    void updateGoodsName(String goodsName,int id,int goodsID) throws Exception;
    void updateGoodsMessage(String goodsMessage,int id,int goodsID) throws Exception;
    void updateGoodsprice(int price,int id,int goodsID) throws Exception;
    void updateGoodsType(String goodsType,int id,int goodsID) throws Exception;
    void updateGoodsNum(int goodsNum,int id,int goodsID) throws Exception;//更新库存
    void updateGoodsNumByName(int goodsNum,String goodsName,String goodsMessage) throws Exception;//更新库存
    void updateGoodsXiaoLiangByName(int goodsXiaoLiang,String goodsName,String goodsMessage) throws Exception;//更新库存
    ResultSet selectByAll(int id, int goodsID) throws Exception;
    void deleteGoods(int id,int goodsID) throws Exception;
    void updateGoodsStatue(String statue,int id,int goodsID)throws Exception;
    void updateGoodsStatueByName(String statue,String goodsName,String goodsMessage)throws Exception;
    void updateGoodsTime(Timestamp time,int id,int goodsID)throws Exception;
    List<goods> selectPart(String goodsName) throws Exception;
    List<goods> selectAllEarly() throws Exception;
    List<goods> selectAllLate() throws Exception;
    List<goods> selectAllXiaoLiangHigh() throws Exception;
    List<goods> selectAllXiaoLiangLower() throws Exception;
    goods selectByGoodsId(int goodsId)throws Exception;
    int selectByGoodsByName(String goodsName,String goodsMessage)throws Exception;
    int selectByGoodsstatueByName(String goodsName,String goodsMessage)throws Exception;
    int selectByGoodsXiaoLiangByName(String goodsName,String goodsMessage)throws Exception;
}
